|
Units Class Hierarchy Classes, Interfaces, Objects and Records Types Variables Constants Functions and Procedures Identifiers |
Unit XLSSheetData5
Description
Uses
Overview
Classes, Interfaces, Objects and Records
Types
Constants
DefaultDeleteOptions = [xdoCellValues,xdoFormats,xdoComments,xdoDataValidations,xdoConditionalFormats,xdoAutofilters,xdoDrawing]; |
CopyAllCells = [ccoCopyValues,
ccoCopyShapes,
ccoCopyNotes,
ccoCopyCondFmt,
ccoCopyValidations,
ccoCopyMerged
]; |
Description
Types
TXLSDeleteOption = (...); |
Values
-
xdoCellValues:
-
xdoFormats:
-
xdoComments:
-
xdoDataValidations:
-
xdoConditionalFormats:
-
xdoAutofilters:
-
xdoDrawing:
|
TPaneType = (...); |
|
Pane type when a worksheet has splitted panes.
Values
-
ptNone:
-
ptFrozen: No panes.
-
ptSplit: Frozen panes,
-
ptFrozenSplit: Splitted panes.
|
TActivePane = (...); |
Values
-
apBottomRight:
-
apTopRight:
-
apBottomLeft:
-
apTopLeft:
|
TWorkspaceOption = (...); |
Values
-
woShowAutoBreaks:
-
woApplyStyles: Automatic page breaks are visible.
-
woRowSumsBelow: Automatic styles are applied to an outline
-
woColSumsRight: Summary rows appear below detail in an outline
-
woFitToPage: Summary columns appear to the right of detail in an outline
-
woOutlineSymbols: Page fit option is on.
|
TWorkbookOption = (...); |
Values
-
woHidden:
-
woIconized: The window is hidden.
-
woHScroll: The window is displayed as an icon.
-
woVScroll: The horizontal scroll bar is displayed.
-
woTabs: The vertical scroll bar is displayed.
|
TWorkbookOptions = set of TWorkbookOption; |
|
The workbook tabs are displayed.
|
TCopyCellsOption = (...); |
|
Options when copying and moving cells.
Values
-
ccoAdjustCells:
-
ccoLockStartRow: Adjust relative cells according to the new location.
-
ccoForceAdjust: Don't adjust the first row.
-
ccoCopyValues: Adjust absolute cell references as well.
-
ccoCopyShapes: Copy cell values.
-
ccoCopyNotes: Copy shape objects.
-
ccoCopyCondFmt: Copy cell notes.
-
ccoCopyValidations: Copy conditional formats.
-
ccoCopyMerged: Copy cell validations.
|
TPrintSetupOption = (...); |
|
Cell values Drawing shapes. Cell notes. Conditional formats. Cell validations. Merged cells.
Values
-
psoLeftToRight:
-
psoPortrait:
-
psoNoColor:
-
psoDraftQuality:
-
psoNotes:
-
psoRowColHeading:
-
psoGridlines:
-
psoHorizCenter:
-
psoVertCenter:
|
TXLSSheetOption = (...); |
Values
-
soGridlines:
-
soRowColHeadings: Show gridlines.
-
soShowFormulas: Show row and column headings.
-
soShowZeros: Show formulas instead of formula result.
|
TSelectedAreaHit = (...); |
Values
-
sahNo:
-
sahInside:
-
sahEdge:
-
sahActiveCell:
|
TSelectedEdgeHit = (...); |
Values
-
sehLeft:
-
sehTop:
-
sehRight:
-
sehBottom:
|
Constants
DefaultDeleteOptions = [xdoCellValues,xdoFormats,xdoComments,xdoDataValidations,xdoConditionalFormats,xdoAutofilters,xdoDrawing]; |
|
|
CopyAllCells = [ccoCopyValues,
ccoCopyShapes,
ccoCopyNotes,
ccoCopyCondFmt,
ccoCopyValidations,
ccoCopyMerged
]; |
|
What parts of the data on a worksheet that shall be copied/moved.
|
Generated by PasDoc 0.12.1 on 2013-03-18 12:36:48
|